CREATE PROCEDURE sp_asi_DeleteCmty
@cmty_seq int
as
delete from Cmty_Read_Tracking where COMMUNITY_SEQ = @cmty_seq
delete from Cmty_News where COMMUNITY_SEQ = @cmty_seq
delete from Cmty_Administrators where COMMUNITY_SEQ = @cmty_seq
delete from Cmty_Subscription where COMMUNITY_SEQ = @cmty_seq
delete from Cmty_Invitees where COMMUNITY_SEQ = @cmty_seq
delete from Cmty_Discussion_Posts where COMMUNITY_SEQ = @cmty_seq
delete from Cmty_Discussion_Forums where COMMUNITY_SEQ = @cmty_seq
delete from Cmty_Shared_Files where COMMUNITY_SEQ = @cmty_seq
delete from Cmty_Shared_Folders where COMMUNITY_SEQ = @cmty_seq
delete from Cmty_Email_Notification where COMMUNITY_SEQ = @cmty_seq
delete from Community where COMMUNITY_SEQ = @cmty_seq
return

GO
GRANT EXECUTE ON  [dbo].[sp_asi_DeleteCmty] TO [IMIS]
GO